package com.sino.tb.auditing.entity;


import java.sql.*;
import xpubbean.Db.*;


public class VecHis {
    private String payerCode;
    private String payerName;
    private String payerSeq;
    public VecHis(String reqSeq, Connection conn) {
        String sql = "select t3.c_code, t3.c_name, t3.c_seq " +
            "  from t_his_info t1, t_flow_operdisp t2, t_vec_payer t3 " +
            " where t2.c_req_seq =  " + reqSeq + " " +
            "   and t2.c_rsp_seq = t1.c_rsp_seq " +
            "   and t1.c_payer_seq = t3.c_seq";
        ResultSetPlus rsp = new ResultSetPlus(sql, conn);

        if (rsp.next()) {
            this.setPayerCode(rsp.getFieldStr("c_code"));
            this.setPayerName(rsp.getFieldStr("c_name"));
            this.setPayerSeq(rsp.getFieldStr("c_seq"));
        }
        rsp.close();
        rsp = null;
    }


    public String getPayerCode() {
        return payerCode;
    }


    public void setPayerCode(String payerCode) {
        this.payerCode = payerCode;
    }


    public String getPayerName() {
        return payerName;
    }


    public void setPayerName(String payerName) {
        this.payerName = payerName;
    }


    public String getPayerSeq() {
        return payerSeq;
    }


    public void setPayerSeq(String payerSeq) {
        this.payerSeq = payerSeq;
    }
}
